<?xml version="1.0" encoding="utf-8"?>
<Query Version="V02" QueryName="PropertyQuery">
  <Columns>
    <ColumnName>KDOR_vwPropertyGeneral.CountyCode</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.QuickRefID</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.PropertyNumber</ColumnName>
    <ColumnName>cama_ComBldg.fbldgname</ColumnName>
    <ColumnName>cama_ComBldgSec.farea</ColumnName>
    <ColumnName>cama_ComBldgSec.foccup</ColumnName>
    <ColumnName>cama_ComBldgSec.fyrblt</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.flbcsfunc</ColumnName>
    <ColumnName>KDOR_vwPropertyGeneral.fpropclass</ColumnName>
    <ColumnName>cama_ComBldg.flbcsstruct</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.TransferValidityCode</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.SaleDate</ColumnName>
    <ColumnName>KDOR_vwPropertyTransfer.Price</ColumnName>
  </Columns>
  <Tables>
    <TableName>cama_ComBldg</TableName>
    <TableName>cama_ComBldgSec</TableName>
    <TableName>KDOR_vwPropertyTransfer</TableName>
  </Tables>
  <ActiveOnly>true</ActiveOnly>
  <Distinct>false</Distinct>
  <GroupBy>false</GroupBy>
  <Criteria>
    <ColumnName>KDOR_vwPropertyGeneral.AdHocTaxYear</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>2015</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>cama_ComBldg.flbcsstruct</ColumnName>
    <Not>false</Not>
    <Test>Equals</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>1331</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Criteria>
    <ColumnName>KDOR_vwPropertyTransfer.SaleDate</ColumnName>
    <Not>false</Not>
    <Test>Greater Than</Test>
    <ColumnValueCheck>false</ColumnValueCheck>
    <Value>12/31/2005</Value>
    <AndOr>And</AndOr>
  </Criteria>
  <Output>CSV</Output>
</Query>